Re: [GENERAL] Re: More PostgreSQL stuff

Поиск
Список
Период
Сортировка
От lynch@lscorp.com (Richard Lynch)
Тема Re: [GENERAL] Re: More PostgreSQL stuff
Дата
Msg-id v02140b05b23a73929ca2@[207.152.64.133]
обсуждение исходный текст
Ответы Re: [GENERAL] Re: More PostgreSQL stuff  (Martin Schulze <joey@finlandia.Infodrom.North.DE>)
Список pgsql-general
At 8:20 AM 10/2/98, Oliver Elphick wrote:
>Copied to PostgreSQL lists, in the hope of comments from the experts...
>
>Martin Schulze wrote:
>  >Is there a way to speed up postgres?  I'm converting one of my
>  >major apps from mSQL to PostgreSQL and PostgreSQL is at least three
>  >times slower.  That's horrible.  With this slowlyness I cannot
>  >install PostgreSQL in the office but only at home.

Also be sure that you have indexed the fields you use most for queries.

And be sure to do a vaccuum after major data insertion/updates.

--
--
-- "TANSTAAFL" Rich lynch@lscorp.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Martin Schulze
Дата:
Сообщение: Re: [GENERAL] Re: More PostgreSQL stuff
Следующее
От: Martin Schulze
Дата:
Сообщение: Re: [GENERAL] Re: More PostgreSQL stuff